query=
-- _f_propiedades.php listar_propiedades()
SELECT
*
FROM propiedad
WHERE
web = 100 -- std
-- cond_empresa
AND cod_empresa = 288 -- mif
AND (
-- propiedades de empresas no excluidas de MLS
(
(web, cod_empresa) NOT IN (
SELECT web_cap, cod_empresa_cap
FROM empresa_config_mls
WHERE web = 100
AND cod_empresa = 288
AND cod_propiedad IS NULL
AND estado = 'C'
)
)
AND
-- propiedades no excluidas de MLS
(
cod_propiedad NOT IN (
SELECT cod_propiedad
FROM empresa_config_mls
WHERE web = 100
AND cod_empresa = 288
AND cod_propiedad IS NOT NULL
AND estado = 'C'
)
)
AND
-- propiedades no excluidas de MLS a nivel global (por usuario administrador de MLS 20230626a)
(
cod_propiedad NOT IN (
SELECT cod_propiedad
FROM empresa_config_mls
WHERE estado = 'X'
)
)
)
-- 20141219 rbz [MLSxx] Inclusión propiedades de Re-max e In-Max en LP360
-- nop!
AND propiedad.cod_oficina = 0
AND ( cod_empresa != 1 OR 1=2 ) -- ceidemo 1 &&
AND propiedad.cod_propiedad NOT IN (0)
AND (
( propiedad.estado IN ('A','O','B') )
|| ( propiedad.estado IN ('V','R') AND fecha_ult_mod > '20240425' AND NOT 1=2 ) -- Vendidas y alquiladas se muestran en webs publicas n_dias despues de la operacion
|| ( propiedad.estado = 'V' AND 0 =1 )
|| ( propiedad.estado = 'R' AND 0 =1 )
|| ( propiedad.estado = '3' AND 0 =1 )
|| ( propiedad.estado = '4' AND 0 =1 )
|| ( propiedad.estado = 'C' AND 0 =1 )
-- || ( propiedad.estado = 'P' AND 1=2 ) -- Prospeccion
|| ( propiedad.estado = 'P' AND 0 =1 )
|| ( propiedad.estado = 'B' AND 0 =1 )
)
AND -- propiedades no publicadas
(
propiedad.publicar IN ('S','P') -- TIPO_WEB_PORTAL
)
AND (
( propiedad.tipo_operacion = '' ) -- El tipo_operacion de la propiedad coincide con el indicado por el usuario
|| ( propiedad.tipo_operacion IN ('V','A') && '' = 'X' ) -- El tipo_operacion de la propiedad es Venta o Alquiler y el indicado por el usuario es X
|| ( propiedad.tipo_operacion = 'X' && ('' = 'V' || '' = 'A') ) -- El tipo_operacion de la propiedad es X y el indicado por el usuario es Venta o Alquiler
|| ( '' = '' ) -- El usuario no ha seleccionado tipo_operacion, mostramos todo
-- [20180806d]
|| ( propiedad.tipo_operacion IN ('H') && '' = 'C' ) -- El tipo_operacion de la propiedad es Alquiler vacacional y el indicado por el usuario es C (alquiler de corta duracion)
)
AND (
cod_valoracion = ''
||
'' = ''
)
-- cond_pais
-- cond_zonas
AND ( propiedad.cod_metazona IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61 ,99) )
-- 20180806d
-- cond_metazonas_portales
-- cond_metazonas_portales: ERROR!! NO OBSERVADO PORTAL 100
AND (
( propiedad.metatipo_propiedad = '' ) -- el metatipo_propiedad es el seleccionado
||
( '' = '' )
)
AND (
( propiedad.tipo_propiedad IN (0) ) -- el tipo de propiedad es el seleccionado
||
( ( '0' = '' || '0' = 0 ) ) -- 20120820 rbz Incluimos negocios en home, además es necesario para que salgan cuando no se indica tipo_propiedad && tipo_propiedad < 200 ) -- No se seleccionó tipo_propiedad (página inicial) No pintamos parcelas, negocios...
||
( ( '0' = '' || '0' = 0 ) && '' = 3 ) -- inversiones
)
AND ( propiedad.superficie >= '' || '' = '' )
AND ( propiedad.superficie <= '' || '' = '' )
AND ( propiedad.superficie_util >= '' || '' = '' )
AND ( propiedad.superficie_util <= '' || '' = '' )
AND ( propiedad.superficie_parcela >= '' || '' = '' )
AND ( propiedad.superficie_parcela <= '' || '' = '' )
AND propiedad.fecha_alta <= '20240510'
AND
( -- Usuario busca Venta/Alquiler (o no selecciona tipo_operacion)
-- propiedad.tipo_operacion IN ('V','A','X')
( propiedad.precio_pvp <= '' || propiedad.precio_pvp IS NULL || '' = '' || '' = '0' )
&& ( propiedad.precio_pvp >= '' || propiedad.precio_pvp IS NULL || '' = '' || '' = '0' )
&& ( propiedad.precio_alquiler <= '' || propiedad.precio_alquiler IS NULL || '' = '' || '' = '0' )
&& ( propiedad.precio_alquiler >= '' || propiedad.precio_alquiler IS NULL || '' = '' || '' = '0' )
)
-- 20131223 rbz
-- 20130128 rbz
-- 20130916 rbz [20130131a]
-- 20130506 rbz
-- [20160430a]
-- 20131028 rbz [20131028a]
-- 20131220 rbz [20131220a]
-- 20130514 rbz [20130514a]
-- 20180305b
-- [3370-4320]
AND propiedad.num_fotos >= 1
AND cod_propiedad NOT IN (1111) -- propiedades_especialitas_excluidas
ORDER BY
CASE
WHEN web = 100 AND cod_empresa = 288 THEN 1 -- propiedades de la propia empresa-
ELSE 9
END,
CASE
WHEN web = 100 AND cod_empresa = 288 THEN prioridad -- propiedades de la propia empresa
-- ELSE 999 -- no deberia ser -1?
ELSE -1
END DESC
, -- 20220315 rbz Añado criterio prioridad (Thorsgren quería para que sus propiedades aparecieran antes que resales)
-- 20220315 rbz Añado este criterio para que las propiedades de MLS aparezcan ordenadas según la empresa asociada
cod_propiedad DESC -- 11
LIMIT 24 -- 24 = 24 - %
-- num_prop_slide= grupo_registros=2 num_max_propiedades_x_pagina=24
OFFSET 48 -- 3 offp
num_tuplas=
24
MAKE AN OFFER
700.000€
Avenida Almeiras
Reference:
352814 - AnaurSize:
1.547m²Usable size:
1.500m²Plot size:
4.169m²Bathrooms:
4Garage:
Private (2 Parking places)Garage type:
CoveredLocation:
ExteriorCeiling height:
HighFloors:
TerrazzoType of windows:
AluminumBuilding year:
1957 (67 year/s)Security measures:
Security doorActivity sector:
Industry
BANK PROPERTY
922.000€
Calle Benito Vicetto, 18
Reference:
352339 - 52965999Size:
6.294m²Usable size:
6.200m²Plot size:
12.095m²Location:
ExteriorCeiling height:
HighBuilding year:
2004 (20 year/s)
PROPERTY OF THE MONTH
602.060€
Calle RIEGO DE AGUA, 19
Reference:
352098 - ALI0000120439Size:
100m²Usable size:
90m²Bedrooms:
2Bathrooms:
2Furnished:
Not furnishedGarage:
NoFloor:
5thLounges:
1 (20.00m²)Built-in cupboards:
YesIndependent dining room:
Yes Furnished kitchen:
Furnished with appliancesKitchen type:
IndependentSuites:
1Service bedrooms:
1Terraces:
1 (12.00m²)Location:
Partially exteriorCeiling height:
RegularStorage room:
NoHot water:
IndividualType hot water:
Electric heaterHeating:
IndividualHeating type:
ElectricityNo. of floors:
5Lift:
YesNeighbors:
1Neighbors in the building:
5Style:
ManorialBuilding year:
1876 (148 year/s)Condition:
Renovated/modernisedScale emissions efficiency:
GScale consumption efficiency:
GEquipment:
Wifi, Refrigerator, Dishwasher, Oven, Mansard, Ceramic hob, Bathtub, Shower plateSecurity measures:
Security door, Video-surveillanceHandicapped access:
No
JUST IN
216.800€
Lugar San Salvador, S/N
Reference:
349998Size:
6.680m²Buildability:
55,4% (3700.72m²)Developable:
Yes
JUST IN
132.000€
Avenida Santa Mariña, S/N
Reference:
349752 - 7235264Size:
699m²
JUST IN
44.300€
Calle Granxa, S/N
Reference:
349749 - 7319529Size:
824m²Developable:
No
OPPORTUNITY
449.300€
Lugar Monte de Fornelos, S/N
Reference:
349748 - 96970Size:
168.060m²Developable:
No
OPPORTUNITY
333.000€
Calle Ferro Couselo, 15
Reference:
349747 - 97504Size:
13.337m²Developable:
Yes
JUST IN
112.000€
Calle Mallou de Abaixo, s/n
Reference:
349745 - PM150166Size:
5.911m²Developable:
No
REDUCED PRICE
195.800€
Calle Asturias, 26
Reference:
331118 - PM80855Size:
113m²Buildability:
771% (871.23m²)Developable:
YesCuatro Caminos, Coruña (A), La Coruña (A Coruña)
Commercial premise for sale
REDUCED PRICE
64.000€
Calle Castiñeiras de Abajo, 14
Reference:
331117 - SRB0001039097Size:
51m²Usable size:
51m²Floor:
Street levelCeiling height:
HighType of ceiling:
RawStyle:
ModernBuilding year:
2011 (13 year/s)Condition:
ProjectEnvironment:
StreetNumber of separated areas:
2Front width:
8.00m.Smoke exit:
YesSomeso, Coruña (A), La Coruña (A Coruña)
Commercial premise for sale
OPPORTUNITY
105.000€
Calle Mendaña de Neyra, 34
Reference:
331115 - SRB0000356088Size:
185m²Usable size:
180m²Floor:
Street levelLocation:
ExteriorWalls:
RawFloors:
unconditionedBuilding year:
2006 (18 year/s)Condition:
ProjectSecurity measures:
Alarm, Security door, Video-surveillanceEnvironment:
StreetCuatro Caminos, Coruña (A), La Coruña (A Coruña)
Commercial premise for sale
OPPORTUNITY
276.400€
Avenida Ramón y Cajal
Reference:
331114 - PM106978Size:
172m²Usable size:
104m²Floor:
1stLocation:
Interior
JUST IN
15.000€
Calle Santiago Casares Paz, 1
Reference:
330735Size:
20m²Floor:
Basement -1Security measures:
Alarm, Video-surveillance
BANK PROPERTY
from
6.270€
Calle Graxal, 4
Reference:
330478 - ALI0000150822Size:
10m²Usable size:
9m²Floor:
Basement -2Security measures:
Security doorAgra del Orzan, Coruña (A), La Coruña (A Coruña)
Parking space for sale
REDUCED PRICE
17.000€
Calle Almirante Mourelle, 42
Reference:
309523 - ALI0000130586Size:
15m²Usable size:
12m²Floor:
Basement -1Security measures:
Alarm, Security door
OPPORTUNITY
124.355€
Urbanización A Palloza, 10
Reference:
309276 - 50093887Size:
284m²
MAKE AN OFFER
1.350.000€
Reference:
305857 - AnMStaSize:
624m²Usable size:
600m²Plot size:
1.104m²Bedrooms:
5Bathrooms:
4Furnished:
Fully furnishedGarage:
Private (2 Parking places)Garage type:
CoveredSwimming pool:
PrivateGarden:
Private (1000.00m²)Floor:
Street levelLounges:
3Built-in cupboards:
YesIndependent dining room:
Yes Furnished kitchen:
Furnished with appliancesKitchen type:
IndependentSuites:
1Balconies:
1 (3.00m²)Courtyards:
1Location:
ExteriorOrientation:
South, SouthwestLocation:
Near the beach, Residential areaViews:
Town, Street, PoolCeiling height:
HighFinishing carpentry :
OakWalls:
FlatFloors:
Porcelain stoneware, Marble, ParquetType of windows:
Glazed, Oscillating, PVCType of glazing:
Soundproof, Thermal bridgeStorage room:
YesHot water:
CentralizedType hot water:
DieselHeating:
CentralizedHeating type:
Diesel fuelNo. of floors:
3Lift:
NoBuilding year:
1960 (64 year/s)Condition:
ExcellentAvailability:
occupied by ownerEmission efficiency value:
27kg/m2/añoConsumption efficiency value:
131kg/m2/añoEquipment:
Antenna, TV, Stereo, Internet, Refrigerator, Washing machine, Dishwasher, Oven, Microwave, Video intercom, , Barbecue, Chimney, Intercom, Ceramic hob, Bathtub, Shower plateSecurity measures:
Alarm, Security door, Video-surveillanceYard size:
80.00m²Handicapped access:
Yes
REDUCED PRICE
86.700€
Calle Benito Vicetto, 12
Reference:
302701 - 45117451Size:
470m²Plot size:
1.232m²Bathrooms:
1Furnished:
Not furnishedGarage:
Private (7 Parking places)Garage type:
ClosedLocation:
ExteriorStorage room:
YesBasement:
NoHot water:
IndividualType hot water:
Electric heaterLift:
NoBuilding year:
1992 (32 year/s)San Pedro de Visma, Coruña (A), La Coruña (A Coruña)
Urban plot for sale
INVESTORS
118.020€
Carretera de Visma a Mazaido, 10
Set of 2 floors for sale in La Coruña. Urban land of predominantly residential use with work in progress located on the Visma to Mazaido highway (DP-3003) west of A Coruña capital. It has a total building area of 743.5 m²t and an area of 888 m²s. It is a sparse urban environment located between Los Rosales and Riazor. According to the registry description of farm 72753, 144.50 m will be discounted for the transfer of the road due to alignment adjustment, so the net area of this farm is estimated at 438.25 m. It has a good connection with the Real Club Deportivo de la Coruña and Outeiro rounds.
Reference:
302143 - ALI0000137433Size:
888m²Buildability:
83,67% (742.9896m²)Developable:
YesMatogrande, Coruña (A), La Coruña (A Coruña)
Commercial premise for sale
BANK PROPERTY
295.000€
Calle José Pascual López-Cortón, 2
Promotion Helios Tower. Set of 3 internally linked offices, on the first floor of the building, which is part of all the premises and offices of this promotion. The promotion is located in the municipality of La Coruña, capital of the province.
The offices have a total constructed area of 957 m². They consist of open space, offices and toilets, in good condition.
Excellently communicated with the main roads of the city (Alfonso Molina, Autopistas A-6, A-9 and N-VI), and next to the EXPOCoruña exhibition center, the Coliseum, the Espacio Coruña Shopping Center and Carrefour. It has a street of taxi and urban bus stop.
Reference:
302121 - 7237442Size:
452m²Usable size:
428m²Garage:
NoFloor:
1stLocation:
ExteriorStorage room:
YesNo. of floors:
1Condition:
To renovate/moderniseHorizontal division:
YesHandicapped access:
NoRonda de Outeiro, Coruña (A), La Coruña (A Coruña)
Commercial premise for sale
PROPERTY OF THE MONTH
226.550€
Ronda de Outeiro, 265
A set of two large commercial premises is sold, ideal for any type of business. Its access is through Ronda Outeiro, in the heart of the city center of A Coruña. These are two very well distributed premises internally, which have different units, all of them very spacious and spacious, which will facilitate your business. They are located in the Agra del Orzán neighborhood, a popular neighborhood in this Galician city, which has the highest population density in the city.
Reference:
302109 - 51193235Size:
424m²Usable size:
380m²Bathrooms:
1Garage:
NoFloor:
Street levelLocation:
ExteriorStorage room:
NoBasement:
YesHot water:
IndividualType hot water:
Electric heaterNo. of floors:
3Lift:
NoCondition:
To renovate/moderniseScale consumption efficiency:
DEnvironment:
Street
GOOD DEAL
4.500€
(£ 3.948 app.)
Ronda de Outeiro, 203
Reference:
302077 - 7246196Size:
984m²Usable size:
820m²Bathrooms:
2Garage:
NoLocation:
ExteriorStorage room:
YesBasement:
NoBuilding year:
2010 (14 year/s)Condition:
Under constructionEnvironment:
StreetFront width:
92.00m.Handicapped access:
YesComunity fee:
(community fee included)New properties
Would you like to receive by email the properties we include in the website?
Selected: 503 properties« backnext »